Conditional formatting

Closed
RV061257 Posts 1 Registration date Wednesday August 19, 2015 Status Member Last seen August 19, 2015 - Aug 19, 2015 at 07:36 PM
 Blocked Profile - Aug 19, 2015 at 08:23 PM
Hello,

I'm trying to write a conditional format formula populating one cell (column of cells) based on the text content of cells in 2 other columns. Example: If cell A1 reads (POS), and cell B1 reads (Single), I want cell C1 to populate with the text $538.50. Is this possible? If formatting doesn't work would a pivot table?

1 response

Blocked Profile
Aug 19, 2015 at 08:23 PM
IN cell C1, place the following (this would be known as a Nested If):
=IF(A1="Pos",IF(B1="Single","$538.00",""),"")

Give that a try. The format of if is as follows: =If(logic statement,true, false).

In this example, we have another test if True, before we can make a true.

Have Fun!


I have said it once, I will say it again. IT!
0