$$Excel-Macros$$ Need for Conditional Formatting

I need a formula for a conditional formatting to make a cell that contain a date comes from another sheet, if that date is less than (today+30 days) then it will change color . -- A.A.A. --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Need for Conditional Formatting

I need a formula for a conditional formatting to make a cell that contain a date comes from another sheet, if that date is less than (today+30 days) then it will change color but this date is hijri not Gregorian. -- A.A.A. --~--~-~--~~~---~--~~ ---