Conditional Formatting

[jjaxjr]

Hello,

I am trying to figure out how to add a formula to fill a cell with different colors based upon whether data is present in two other cells. Attached is an example. If columns A and B have data present then column C should fill with green, if only column A has data then yellow and if neither column has data then red. Any help would be appreciated.

JJ

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C
1
2	01/01/2022	15/01/2022
3	01/01/2022
4
5
6
7
Data

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2:C8	Expression	=AND(A2="",B2="")	text	NO
C2:C8	Expression	=AND(A2<>"",B2="")	text	NO
C2:C8	Expression	=AND(A2<>"",B2<>"")	text	NO

 

[jjaxjr]

Thank you for the response! Where would I go to enter the "Cells with Conditional Formatting" portion of your answer?

JJ

 

[Fluff]

Goto conditional formatting, new rule, use a formula & enter the formula shown. You will need to do it for each formula

 

[jjaxjr]

Got it, thank you. Is there any way to pivot the data to pull in formatting. I am trying to get the data to look like rows 10 through 12 as my next step.

 

[Fluff]

As this is a totally different question, it needs a new thread. Thanks

 

[jjaxjr]

Thank you again for your help!

 

[Fluff]

You're welcome thanks for the feedback.