Conditional Formatting (two sheets three cells)
I need to do a Conditional Format that will check the date that I have set on
Sheet 1 Cell A3 compared to Sheet 2 Cell E1. If the Date in is before SH1,CA3 then Cell A1 on sheet 2 will have a red background. Can I do this? Thanks Keith |
Conditional Formatting (two sheets three cells)
You need to name the cell on Sheet1 and compare the name to cell E1.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "KAnoe" wrote in message ... I need to do a Conditional Format that will check the date that I have set on Sheet 1 Cell A3 compared to Sheet 2 Cell E1. If the Date in is before SH1,CA3 then Cell A1 on sheet 2 will have a red background. Can I do this? Thanks Keith |
All times are GMT +1. The time now is 06:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com