fillcolor

S

SCOTT MEINERS

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
 
J

Jim

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
 
B

Bob Phillips

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)
 
M

Mark Graesser

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
[email protected]

----- 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
 
Top