Tag Info

New answers tagged

3

Here is what you can do: RightClick B2 → select Conditional formatting → select Custom Formula is (from the List) Enter the following formula in the textbox: =b2>=c2 Check the Background Color and select green color Click on Add another rule Select Custom Formula is (from the List) Enter the following formula in the textbox: =b2<c2 Check ...


1

Yes! Highlight the cells you want to format. Go to Format > Conditional Formatting. Once you're in the conditional formatting dialog, choose "Custom Formula Is" from the select box (it's the last option). In the text field type: =len(XY)>30 X will be the column you're in and Y will be the row you want it to start at. So if you want to check the entire ...


1

Please try a Custom formula is like so: =and(A1>today()-365,A1<today()-180) which may be applied not just to A1 but say to the whole of ColumnA if the Range: is A:A.



Top 50 recent answers are included