conditional formatting question

d0wnt0wn

Well-known Member
Joined
Oct 28, 2002
Messages
771
conditional formatting question.... can i format a1 so that if a2 is higher than 50 the cell turns red but if a value gets entered into a3 the cell will go back to white???
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

ken2step

Well-known Member
Joined
Jan 9, 2003
Messages
632
Condition 1
Formula is =$A$3<>"" Format is Default

Condition 2
Formula is = =$A$2>50 Format is Cell Shade Red
 

ken2step

Well-known Member
Joined
Jan 9, 2003
Messages
632
What is in cells A2 and A3....if you have say 65 in cell A2, A1 is red.....but if you enter a number in A3 it returns to white. I thought that was what I read you wanted.
 

d0wnt0wn

Well-known Member
Joined
Oct 28, 2002
Messages
771
ya for some reason it didnt work with the "" at the end but it worked as a <>0... thanks for your help
 

Forum statistics

Threads
1,147,679
Messages
5,742,575
Members
423,738
Latest member
AshleyKitsune

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top