Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses