Difficult conditional formatting question in Excel?

Question

OK I am trying to add conditional "conditional formatting" based on the value of other cell. Please see the image here

http://picturepush.com/public/7972623

I have applied conditional formatting for columns F:O so that blank cells are conditionally formatted to a color, these are some tasks that have been checked as Done (D) or not Applicable (NA) and Incomplete (Colored), so when the cells are colored I know I have missed doing something but now my sheet looks messy. Is there a way I can have the conditional formatting rule applied only when I have a value in column A, so if the column A value is blank, no conditional formatting will apply to columns F through O. Say in this case, if cell A8 is blank, I want columns F:O to not apply the conditional formatting, but if I enter a value in cell A8, the blank cells will color code. I did my own research but I was unable to find anything that helped. All suggestions are welcome.

Thank you in advance for your help.

Answer 1

You can use a formula as your conditional formatting rule to do as you wish.



Highlight cells F:O for all rows you wish to conditionally format. For example, cells F1:O30.



For Excel 2003 and prior:

===================



Go to Format > Conditional Formatting.



In the drop down beneath Condtition1, select 'Formula Is'.



Enter this formula in the textbox to the right:



=AND($A1<>"",F1="")



Select 'Format', select the Pattern tab, and select the color of Gray you wish to use to format.



Click 'OK' twice.



Select a cell in column A, within the rows formatted, and enter any value. Cells F:O in that row will fill Gray.



Make an entry in any cell in columns F:O in that row and the formatted will be removed.



--------------------------------------…



For Excel 2010 (and probably 2007):

============================



Highlight the cells in columns F:O as above.



Select the Home tab and click 'Conditional Formatting' in the Styles group.



Select 'New Rule'.



In the 'Select a rule type' section, select 'Use a formula to determine which cells to format'.



In the 'Format values where this formula is true' textbox, enter the formula:



=AND($A1<>"",F1="")



Click 'Format'.



Select the 'Fill' tab, select the color of gray you wish to use, and click 'OK' twice.

3 hours ago - Edit - Delete

Answer 2

1. Format all the cells in F:O with no fill color.



2. Set a CF rule that clears formatting when the values "D" or "NA" are entered in F:O:



CF #2 for F1:O1

=OR(F1="D", F1="NA")

Apply no fill



3. Set a CF rule that fills F:O if column A has a value. The rule uses absolute referencing ($) in order to properly apply:



CF for F1:O1

=$A1

Apply gray fill



CF isn't checking if F1 through O1 are equal to A1, it is checking whether A1 is TRUE (i.e. anything but 0 which is FALSE). If you wish, you can instead use this formula that is more straightforward:

=NOT(ISBLANK($A1))



The first rule needs to be ahead of the second rule. In Excel 2007/2010, the first CF rule ('no fill') also needs to have the "Stop if true" property checked in the Manage Rules dialog. This way, the 'no fill' rule overrides the 'fill' rule when a value is placed in column A.

Answer 3

your suited wager is in simple terms to make yet another column the place you place the different characters you do no longer desire formatted in case you need to connect them jointly later in simple terms merge the cells jointly different than that i can't think of of a thank you to apply distinctive formatting in one cellular in super numbers.