Conditional Formatting - further assistance required

  • Thread starter Thread starter Aaron Hodson \(Coversure\)
  • Start date Start date
A

Aaron Hodson \(Coversure\)

Hello all,

I require to format 17 cells in a row ie: A1:Q1 to turn red, dependent on
text being inserted in K1

Please help,

Thanks

Aaron
 
In K1 I typed "red" and in K2 I typed "green"
I selected A1:Q2
With Condition Formatting I used:
Formula is =$K1="red" and set font colour to red
Now all the text in row 1 is red but not in row 2 until I change K2 to
"red" - of course any word can be used (like "Labour")
Hope this is what was wanted
best wishes
 
Worked like a treat,

Thank you very much!

Bernard Liengme said:
In K1 I typed "red" and in K2 I typed "green"
I selected A1:Q2
With Condition Formatting I used:
Formula is =$K1="red" and set font colour to red
Now all the text in row 1 is red but not in row 2 until I change K2 to
"red" - of course any word can be used (like "Labour")
Hope this is what was wanted
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
Click to expand...
 
Back
Top