ExcelBanter - conditional format

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

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

- - conditional format (https://www.excelbanter.com/excel-discussion-misc-queries/183534-conditional-format.html)

Sue

conditional format

Need help with a conditional format on cell F1
if value in F1 is blank and value in A1 is greater than 1, highlight field

yshridhar

conditional format

formula is
=AND(F1="",A11)
best wishes
Sreedhar
"Sue" wrote:

Need help with a conditional format on cell F1
if value in F1 is blank and value in A1 is greater than 1, highlight field

Sue

conditional format

That worked great thanks. Saved me lots of time

All times are GMT +1. The time now is 08:12 PM.