Is there a way to conditionally format a range of cells [$C$6:$AT$25 or named range] using formula for the following? –

Firstly, check if cell is not blank [suggested code; NOT(ISBLANK($C$6:$AT$25))].

Then check column A on the same row as that cell and use the following rule:

If CATEGORY1 then format fill yellow,

If CATEGORY2 then format fill blue,

If CATEGORY3 then format fill green,

If CATEGORY4 then format fill red, and so on…

Is this possible in conditional formatting using formula and if so what is the best method?

​Is there a way to conditionally format a range of cells [$C$6:$AT$25 or named range] using formula for the following? -Firstly, check if cell is not blank [suggested code; NOT(ISBLANK($C$6:$AT$25))].Then check column A on the same row as that cell and use the following rule:If CATEGORY1 then format fill yellow,If CATEGORY2 then format fill blue,If CATEGORY3 then format fill green,If CATEGORY4 then format fill red, and so on…Is this possible in conditional formatting using formula and if so what is the best method?  Read More

​