fillcolor

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I was wondering if the following is possible to do with a function or by some other means:

If the number in column "C" = 25 then modify the fill color of columns "B to T" to blue.

Thanks
 
Select the range in B:T that you want. Format>Conditional Formatting>Formula
Is (from the dropdown)>=$C2=25>Format for the change if TRUE>OK

This will format all rows where the C column value =25.

If you want to format ALL the cells if the specific value in Cn equals 25
use the formula:
=$C$2=25
 
Scott,

Use Conditional Formatting, and test for the cell in C to be 25, and set the
pattern colour from the format button to blue.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Scott,
You can do this with conditional formatting.

1) Select columns B through T
2) goto Format>Conditional_Formatting on the pull down menu.
3) Select "Formula Is" and enter =$C2=25 in the formula field.
4) Click Format Button
5) goto Patterns tab and select collor
6)OK. OK.

Good Luck,
Mark Graesser
(e-mail address removed)

----- SCOTT MEINERS wrote: -----

Hello,

I was wondering if the following is possible to do with a function or by some other means:

If the number in column "C" = 25 then modify the fill color of columns "B to T" to blue.

Thanks
 
Back
Top