How can I do a conditional format to change the color when my formula shows a "loss" ?

**Gebo** · 02-23-2021, 10:28 AM

How can I format a cell with a conditional format to the change the color in the cell when my formula shows a "loss". Either a red color change on the text or a red background with my
formula shows a "loss'? Below is the formula:

=IF(K8=0,"",IF(K8<=(O8),"LOSS",IF(K8>=(O8),"GAIN")))

**Richard Buttrey** · 02-23-2021, 10:38 AM

Just use

=K8="LOSS"

or

=K8<=O8

**Gebo** · 02-23-2021, 10:52 AM

Thanks Rich for a quick replay and help. It worked

George

How can I do a conditional format to change the color when my formula shows a "loss" ?

LinkBack

Thread Tools

Rate This Thread

Display

How can I do a conditional format to change the color when my formula shows a "loss" ?

Re: How can I do a conditional format to change the color when my formula shows a "loss" ?

Re: How can I do a conditional format to change the color when my formula shows a "loss" ?

Thread Information

Users Browsing this Thread

Similar Threads

Auto Change Date format from "." to "/" when copy data from SAP T-code - VF05

Conditional format to change cell color if over "x" days late

[SOLVED] formula help: conditional format of one column based on "YES"/"NO" content of four others!

[SOLVED] How to USE """"" cells count """"" change font color

Change cell color in a cell formula "without conditional"

Custom date format shows "051117.Thu" for today. Way to have "051117.Th", instead?

Conditional formatting-Can I format a cell based on the "filled" color of another cel

Bookmarks

Bookmarks

Posting Permissions