Hey!
I was hoping anyone could help me out with this one, I'm new to excel.
I want this formula to be true in conditional formatting;
R10C16 = blank
R72C16=212
if those two are true I would like to format a cell.
Thanks!
Hey!
I was hoping anyone could help me out with this one, I'm new to excel.
I want this formula to be true in conditional formatting;
R10C16 = blank
R72C16=212
if those two are true I would like to format a cell.
Thanks!
Use the option that says "Use a formula to determine...."
Formula:Please Login or Register to view this content.
Do you have the R1C1 format turned on? I almost never see people do that.
ETA: I just looked at your other thread. You will need to use ";" instead of "," for your localization.
Last edited by 6StringJazzer; 06-24-2019 at 08:37 PM.
No disadvantages at all, just that almost everybody uses the default A1 format.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks