ExcelBanter - Formula if a conditional format exists

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula if a conditional format exists (https://www.excelbanter.com/excel-discussion-misc-queries/122984-formula-if-conditional-format-exists.html)

Shu of AZ

Formula if a conditional format exists

If A1=1, and B1 has a conditional format that changes the color to red if A1
equals 1, what is the IF formula to change C1 to a zero if B1 is red.

Gary''s Student

Formula if a conditional format exists

=IF(A1=0,1)

The same condition applies
--
Gary''s Student

"Shu of AZ" wrote:

If A1=1, and B1 has a conditional format that changes the color to red if A1
equals 1, what is the IF formula to change C1 to a zero if B1 is red.

All times are GMT +1. The time now is 12:15 AM.