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

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

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

26 responses
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses
What shall i do after formatting my laptop?
upen91 -
jack4rall -

1 response
Conditional Formatting: 3 range of numbers
LCC -
LCC -

2 responses