Conditional Formatting?

0 ⤊

Conditional Formatting?

What would the formula be if I wanted to Excel to format a cell only if it contained something?

Also, will VLOOKUP carry over conditional formatting?

2007-08-09 13:42:45 · 2 answers · asked by Anonymous in Computers & Internet ➔ Software

2 answers

Conditional formatting is not created by using a formula in the cell.

Go to the Format Menu -> Conditional Formatting...

Then fill in all the conditions and formatting, and keep clicking add until you have all the conditions.

Click OK.

Yes, Vlookup will not change the conditional formatting, just remember that the value is what is coming from the lookup table.

2007-08-10 02:30:01 · answer #1 · answered by vbmica 7 · 0⤊ 0⤋

high flier

2016-11-14 19:51:49 · answer #2 · answered by oscar 1 · 0⤊ 0⤋